package com.springbootblog.dao.sqlBuilder;

import java.util.Map;

public class FooterSqlBuilder
{
    public String getTotalBrowse(Map<String, Object> param)
    {
        String sql = "SELECT COUNT(id) AS number FROM browse";
        return sql;
    }

    public String getTotalArticle(Map<String, Object> param)
    {
        String sql = "SELECT COUNT(id) AS number FROM article WHERE is_show = 1 ";
        return sql;
    }

    public String getTotalUser(Map<String, Object> param)
    {
        String sql = "SELECT COUNT(id) AS number FROM user ";
        return sql;
    }

    public String getTotalMessage(Map<String, Object> param)
    {
        String sql = "SELECT COUNT(id) AS number FROM message ";
        return sql;
    }

    public String getFriendLinkList(Map<String, Object> param)
    {
        String sql = "SELECT * FROM friendlink WHERE status = 1 ORDER BY sort_no ASC LIMIT 3 ";
        return sql;
    }




}
